Oracle Application Express 4 Recipes by Edmund Zehoo

Author:Edmund Zehoo
Language: eng
Format: mobi, pdf
Publisher: Apress®
Published: 2011-07-04T16:00:00+00:00

Figure 5-23. The Europe (without Russia) map

Skip past the next two pages of the wizard.

At the Map Attributes step of the wizard, specify a map title (such as ACME EUROPEAN SALES).

In the next page of the wizard, specify the following SQL query: SELECT NULL LINK, COUNTRY, SUM(SALES) FROM SALESDATA GROUP BY COUNTRY

You should now see the screen shown in Figure 5-24.

Figure 5-24. Specifying the datasource for the map

Skip the next step of the wizard and click the Finish button to create the map.

Run the page. You should see the map with your sales data displayed on each corresponding country, as shown in Figure 5-25.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.